 |
|
0 items |
|
|
|
 |
Categories |
|
|
|
Bestsellers |
|
|
2006 - MySQL server has gone away
select p.products_id, p.products_image, p.products_tax_class_id, p.products_price, pd.products_name from products p left join products_to_categories p2c using (products_id), products_description pd where ('83-000,84-279,84-000,453-187,453-000,453-182,86-284,87-284,88-284,89-284,90-284,92-284,93-284,94-284,451-188,451-000,451-181,452-189,452-000,452-181,450-190,450-000,450-181,448-187,448-000,448-181,124-277,124-000,390-139,390-000,390-134,387-141,387-000,387-133,388-142,388-000,388-133,389-143,389-000,389-133,386-140,386-000,386-133,455-189,455-000,455-182,391-140,391-000,391-134,392-141,392-000,392-134,149-277,149-300,149-000,186-284,186-0,186-000,385-139,385-000,385-133,382-140,382-000,382-132,383-141,383-000,383-132,384-142,384-000,384-132,361-125,361-000,361-120,358-127,358-000,358-120,359-128,359-000,359-120,176-284,176-0,181-279,181-000,381-132,381-139,381-000,393-142,393-000,393-134,360-126,360-000,360-120,545-000,576-294,576-000,220-281,220-000,222-281,222-000,223-281,223-000,224-282,224-000,225-282,225-000,226-282,226-000,227-282,227-000,228-283,228-000,229-283,229-000,230-283,230-000,231-283,231-000,232-288,232-000,233-288,233-000,234-288,234-000,235-288,235-000,236-288,236-000,237-289,237-000,238-289,238-000,239-289,239-000,240-289,240-000,241-290,241-000,242-290,242-000,243-290,243-000,416-290,416-000,245-292,245-000,246-292,246-000,247-292,247-000,248-292,248-000,249-291,249-000,250-291,250-000,251-291,251-000,252-291,252-000,253-293,253-000,254-293,254-000,255-293,255-000,256-293,256-000,257-296,257-000,258-296,258-000,259-296,259-000,260-296,260-000,415-281,415-000,285-290,285-000,322-279,322-000,454-190,454-000,454-182,353-285,346-278,346-000,347-278,347-000,348-278,348-000,349-285,351-285,352-285,362-129,362-000,362-120,363-125,363-000,363-121,364-126,364-000,364-121,365-127,365-000,365-121,366-128,366-000,366-121,367-125,367-000,367-122,368-126,368-000,368-122,369-127,369-000,369-122,370-128,370-000,370-122,371-129,371-000,371-122,372-125,372-000,372-123,373-126,373-000,373-123,374-127,374-000,374-123,375-128,375-000,375-123,376-125,376-000,376-124,377-126,377-000,377-124,378-127,378-000,378-124,379-128,379-000,379-124,394-139,394-000,394-135,395-140,395-000,395-135,396-141,396-000,396-135,397-142,397-000,397-135,398-143,398-000,398-135,399-139,399-000,399-137,400-140,400-000,400-137,401-141,401-000,401-137,402-142,402-000,402-137,403-139,403-000,403-138,404-140,404-000,404-138,405-141,405-000,405-138,406-142,406-000,406-138,407-139,407-000,407-144,408-140,408-000,408-144,409-141,409-000,409-144,410-142,410-000,410-144,419-172,419-000,419-163,420-171,420-000,420-163,421-173,421-000,421-163,423-171,423-000,423-164,424-172,424-000,424-164,425-173,425-000,425-164,427-172,427-000,427-165,428-171,428-000,428-165,429-173,429-000,429-165,431-171,431-000,431-166,432-172,432-000,432-166,433-173,433-000,433-166,434-174,434-000,434-166,477-194,477-000,477-191,436-171,436-000,436-167,437-172,437-000,437-167,438-173,438-000,438-167,440-171,440-000,440-168,441-172,441-000,441-168,442-173,442-000,442-168,443-174,443-000,443-168,456-188,456-000,456-182,445-171,445-000,445-169,446-172,446-000,446-169,447-173,447-000,447-169,457-188,457-000,457-183,458-189,458-000,458-183,459-190,459-000,459-183,460-187,460-000,460-183,461-187,461-000,461-184,462-190,462-000,462-184,463-189,463-000,463-184,464-188,464-000,464-184,465-188,465-000,465-185,466-189,466-000,466-185,467-190,467-000,467-185,468-187,468-000,468-185,469-187,469-000,469-186,470-190,470-000,470-186,471-188,471-000,471-186,472-189,472-000,472-186,473-186,473-000,474-186,474-000,475-186,475-000,476-186,476-000,478-195,478-000,478-191,479-196,479-000,479-191,480-197,480-000,480-191,481-194,481-000,481-192,482-195,482-000,482-192,483-196,483-000,483-192,484-197,484-000,484-192,485-194,485-000,485-193,486-195,486-000,486-193,487-196,487-000,487-193,488-193,488-000,489-193,489-000,490-74,490-79,490-193,490-197,490-000,491-193,491-000,492-193,492-000,528-279,528-000,531-205,531-000,532-205,532-000,533-205,533-000,534-205,534-000,542-000,543-205,543-000,544-205,544-000,550-287,549-287,552-205,552-000,553-205,553-000,557-205,557-000,558-300,558-000,562-203,562-000,560-233,560-236,560-000,561-300,561-000,563-203,563-000,564-203,564-000,565-203,565-000,566-203,566-000,567-203,567-000,568-203,568-000,569-203,569-000,570-300,570-000,571-234,571-235,571-000,573-285,574-285,575-300,575-000,577-295,577-000,578-284,579-284,584-205,584-000,585-205,585-000,588-294,588-000,589-294,589-000,590-294,590-000,591-295,591-000,592-295,592-000,593-295,593-000,600-278,601-000,614-262,613-277,613-000,615-262,615-000,616-000,618-205,618-000,621-205,621-000,622-205,622-000,624-269,624-000,630-262,630-000,632-286,633-000,633-205,635-286,636-286,639-0,639-000,644-300,644-000,645-286,646-286,647-286,654-000,655-000,656-000,657-262,657-000,658-000,659-234,659-000,660-234,660-000,') NOT LIKE CONCAT('%', p.products_id, '-', p2c.categories_id, ',%') and p.products_status = '1' and p.sold_in_bundle_only = 'no' and pd.language_id = '1' and p.products_id = pd.products_id and p2c.categories_id IN (47,263,264,48,207,237,257,258,270,272,49,80,265,273,274,275,86,87,88,89,90,91,92,93,94,95,96,250,113,206,243,244,261,52,161,170,171,172,173,174,162,163,164,165,166,167,168,169,53,57,58,130,139,140,141,142,143,131,132,133,134,135,137,138,144,59,218,234,271,298,61,118,125,126,127,128,129,119,120,121,122,123,124,62,63,71,72,73,74,75,198,199,76,79,81,82,83,102,103,267,78,175,179,187,188,189,190,180,181,182,183,184,185,186,176,177,194,195,196,197,178,191,192,193,114,115,233,235,202,208,203,205,210,211,212,213,214,215,216,217,219,221,222,223,224,225,226,227,228,230,231,232,229,236,238,239,240,241,242,245,246,247,248,251,252,253,254,255,259,260,262,269,299,276,281,282,283,288,289,290,291,292,293,294,295,296,277,278,300,279,280,284,285,286,287,0) and ('83-000,84-279,84-000,453-187,453-000,453-182,86-284,87-284,88-284,89-284,90-284,92-284,93-284,94-284,451-188,451-000,451-181,452-189,452-000,452-181,450-190,450-000,450-181,448-187,448-000,448-181,124-277,124-000,390-139,390-000,390-134,387-141,387-000,387-133,388-142,388-000,388-133,389-143,389-000,389-133,386-140,386-000,386-133,455-189,455-000,455-182,391-140,391-000,391-134,392-141,392-000,392-134,149-277,149-300,149-000,186-284,186-0,186-000,385-139,385-000,385-133,382-140,382-000,382-132,383-141,383-000,383-132,384-142,384-000,384-132,361-125,361-000,361-120,358-127,358-000,358-120,359-128,359-000,359-120,176-284,176-0,181-279,181-000,381-132,381-139,381-000,393-142,393-000,393-134,360-126,360-000,360-120,545-000,576-294,576-000,220-281,220-000,222-281,222-000,223-281,223-000,224-282,224-000,225-282,225-000,226-282,226-000,227-282,227-000,228-283,228-000,229-283,229-000,230-283,230-000,231-283,231-000,232-288,232-000,233-288,233-000,234-288,234-000,235-288,235-000,236-288,236-000,237-289,237-000,238-289,238-000,239-289,239-000,240-289,240-000,241-290,241-000,242-290,242-000,243-290,243-000,416-290,416-000,245-292,245-000,246-292,246-000,247-292,247-000,248-292,248-000,249-291,249-000,250-291,250-000,251-291,251-000,252-291,252-000,253-293,253-000,254-293,254-000,255-293,255-000,256-293,256-000,257-296,257-000,258-296,258-000,259-296,259-000,260-296,260-000,415-281,415-000,285-290,285-000,322-279,322-000,454-190,454-000,454-182,353-285,346-278,346-000,347-278,347-000,348-278,348-000,349-285,351-285,352-285,362-129,362-000,362-120,363-125,363-000,363-121,364-126,364-000,364-121,365-127,365-000,365-121,366-128,366-000,366-121,367-125,367-000,367-122,368-126,368-000,368-122,369-127,369-000,369-122,370-128,370-000,370-122,371-129,371-000,371-122,372-125,372-000,372-123,373-126,373-000,373-123,374-127,374-000,374-123,375-128,375-000,375-123,376-125,376-000,376-124,377-126,377-000,377-124,378-127,378-000,378-124,379-128,379-000,379-124,394-139,394-000,394-135,395-140,395-000,395-135,396-141,396-000,396-135,397-142,397-000,397-135,398-143,398-000,398-135,399-139,399-000,399-137,400-140,400-000,400-137,401-141,401-000,401-137,402-142,402-000,402-137,403-139,403-000,403-138,404-140,404-000,404-138,405-141,405-000,405-138,406-142,406-000,406-138,407-139,407-000,407-144,408-140,408-000,408-144,409-141,409-000,409-144,410-142,410-000,410-144,419-172,419-000,419-163,420-171,420-000,420-163,421-173,421-000,421-163,423-171,423-000,423-164,424-172,424-000,424-164,425-173,425-000,425-164,427-172,427-000,427-165,428-171,428-000,428-165,429-173,429-000,429-165,431-171,431-000,431-166,432-172,432-000,432-166,433-173,433-000,433-166,434-174,434-000,434-166,477-194,477-000,477-191,436-171,436-000,436-167,437-172,437-000,437-167,438-173,438-000,438-167,440-171,440-000,440-168,441-172,441-000,441-168,442-173,442-000,442-168,443-174,443-000,443-168,456-188,456-000,456-182,445-171,445-000,445-169,446-172,446-000,446-169,447-173,447-000,447-169,457-188,457-000,457-183,458-189,458-000,458-183,459-190,459-000,459-183,460-187,460-000,460-183,461-187,461-000,461-184,462-190,462-000,462-184,463-189,463-000,463-184,464-188,464-000,464-184,465-188,465-000,465-185,466-189,466-000,466-185,467-190,467-000,467-185,468-187,468-000,468-185,469-187,469-000,469-186,470-190,470-000,470-186,471-188,471-000,471-186,472-189,472-000,472-186,473-186,473-000,474-186,474-000,475-186,475-000,476-186,476-000,478-195,478-000,478-191,479-196,479-000,479-191,480-197,480-000,480-191,481-194,481-000,481-192,482-195,482-000,482-192,483-196,483-000,483-192,484-197,484-000,484-192,485-194,485-000,485-193,486-195,486-000,486-193,487-196,487-000,487-193,488-193,488-000,489-193,489-000,490-74,490-79,490-193,490-197,490-000,491-193,491-000,492-193,492-000,528-279,528-000,531-205,531-000,532-205,532-000,533-205,533-000,534-205,534-000,542-000,543-205,543-000,544-205,544-000,550-287,549-287,552-205,552-000,553-205,553-000,557-205,557-000,558-300,558-000,562-203,562-000,560-233,560-236,560-000,561-300,561-000,563-203,563-000,564-203,564-000,565-203,565-000,566-203,566-000,567-203,567-000,568-203,568-000,569-203,569-000,570-300,570-000,571-234,571-235,571-000,573-285,574-285,575-300,575-000,577-295,577-000,578-284,579-284,584-205,584-000,585-205,585-000,588-294,588-000,589-294,589-000,590-294,590-000,591-295,591-000,592-295,592-000,593-295,593-000,600-278,601-000,614-262,613-277,613-000,615-262,615-000,616-000,618-205,618-000,621-205,621-000,622-205,622-000,624-269,624-000,630-262,630-000,632-286,633-000,633-205,635-286,636-286,639-0,639-000,644-300,644-000,645-286,646-286,647-286,654-000,655-000,656-000,657-262,657-000,658-000,659-234,659-000,660-234,660-000,') NOT LIKE CONCAT('%', p.products_id, '-000,%') order by p.products_date_added desc limit 10
[TEP STOP]
|
